1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10
11 namespace SoftQuanLyNhaHang.Controllers
12 {
13 class KhachHangCtrl_tbl
14 {
15
16 // Method Add
17 public static int InsertKhachHang_tbl(int _idKhachHang, string _tenKhachHang, string _soDienThoai, string _diaChi, int _trangThai, double _diemTichLuy, double _tongTien, double _tienKhach, double _tienTraLai, DateTime _ngayMuaHang, string _ghiChu, string _TrangThaiGiaoDich)
18 {
19 try
20 {
21 Models.KhachHangMod_tbl _khachHang = new Models.KhachHangMod_tbl(_idKhachHang, _tenKhachHang, _soDienThoai, _diaChi, _trangThai, _diemTichLuy, _tongTien, _tienKhach, _tienTraLai, _ngayMuaHang, _ghiChu, _TrangThaiGiaoDich);
22 return _khachHang.InsertKhachHang_tbl();
23 }
24 catch
25 {
26 return 0;
27 }
28 }
29 // Method Update
30 public static int UpdateKhachHang_tbl(int _idKhachHang, string _tenKhachHang, string _soDienThoai, string _diaChi, int _trangThai, double _diemTichLuy, double _tongTien, double _tienKhach, double _tienTraLai, DateTime _ngayMuaHang, string _ghiChu, string _TrangThaiGiaoDich)
31 {
32 try
33 {
34 Models.KhachHangMod_tbl _khachHang = new Models.KhachHangMod_tbl(_idKhachHang, _tenKhachHang, _soDienThoai, _diaChi, _trangThai, _diemTichLuy, _tongTien, _tienKhach, _tienTraLai, _ngayMuaHang, _ghiChu, _TrangThaiGiaoDich);
35 return _khachHang.UpdateKhachHang_tbl();
36 }
37 catch
38 {
39 return 0;
40 }
41
42 }
43 // Method Delete
44 public static int DeleteKhachHang_tbl(int _idKhachHang)
45 {
46 try
47 {
48 Models.KhachHangMod_tbl _khachHang = new Models.KhachHangMod_tbl(_idKhachHang);
49 return _khachHang.DeleteKhachHang_tbl();
50 }
51 catch
52 {
53 return 0;
54 }
55
56 }
57
58 // Method Update
59 public static int tbl_KhachHang_Update_TrangThai(int _idKhachHang,string _soDienThoai, int _trangThai)
60 {
61 try
62 {
63 Models.KhachHangMod_tbl _khachHang = new Models.KhachHangMod_tbl(_idKhachHang, _soDienThoai, _trangThai);
64 return _khachHang.tbl_KhachHang_Update_TrangThai();
65 }
66 catch
67 {
68 return 0;
69 }
70
71 }
72 //Lây điểm tích lũy theo sdt khách hàng
73 public static DataSet FillDataSet_getDiemTichLuyBySoDienThoai(int _idKhachHang, string _soDienThoai)
74 {
75 try
76 {
77 Models.KhachHangMod_tbl sp = new Models.KhachHangMod_tbl(_idKhachHang, _soDienThoai);
78 return sp.FillDataSet_getDiemTichLuyBySoDienThoai();
79
80 }
81 catch
82 {
83 return null;
84 }
85 }
86
87 //tbl_KhachHang_GetsById_SDT
88 //lấy kh và sdt
89 public static DataSet FillDataSet_getsId_SDT(int _idKhachHang, string _soDienThoai)
90 {
91 try
92 {
93 Models.KhachHangMod_tbl sp = new Models.KhachHangMod_tbl(_idKhachHang, _soDienThoai);
94 return sp.FillDataSet_getsId_SDT();
95
96 }
97 catch
98 {
99 return null;
100 }
101 }
102
103 //tim theo kh string
104 public static DataSet FillDataSet_getIdKh_TimKiem(string _idKhachHangStr, string _soDienThoai, string _tenKhachHang)
105 {
106 try
107 {
108 Models.KhachHangMod_tbl sp = new Models.KhachHangMod_tbl(_idKhachHangStr, _soDienThoai, _tenKhachHang);
109 return sp.FillDataSet_getIdKh_TimKiem();
110
111 }
112 catch
113 {
114 return null;
115 }
116 }
117
118 //lay danh sach khach hang
119 public static DataSet FillDataSet_KhachHang_BySearch(int _idKhachHang, string _tenKhachHang, string _soDienThoai, string _diaChi, int _trangThai, double _diemTichLuy, double _tongTien, double _tienKhach, double _tienTraLai, DateTime _ngayMuaHang, string _ghiChu, string _TrangThaiGiaoDich, int _pageSize, int _pageIndex)
120 {
121 try
122 {
123 Models.KhachHangMod_tbl sp = new Models.KhachHangMod_tbl( _idKhachHang, _tenKhachHang, _soDienThoai, _diaChi, _trangThai, _diemTichLuy, _tongTien, _tienKhach, _tienTraLai, _ngayMuaHang, _ghiChu, _TrangThaiGiaoDich, _pageSize, _pageIndex);
124 return sp.FillDataSet_KhachHang_BySearch();
125 }
126 catch
127 {
128 return null;
129 }
130 }
131
132 //lay tong khach hang
133 public static DataSet FillDataSet_KhachHang_Count_ByNgayMua(int _idKhachHang, string _tenKhachHang, string _soDienThoai, string _diaChi, int _trangThai, double _diemTichLuy, double _tongTien, double _tienKhach, double _tienTraLai, DateTime _ngayMuaHang, string _ghiChu, string _TrangThaiGiaoDich)
134 {
135 try
136 {
137 Models.KhachHangMod_tbl sp = new Models.KhachHangMod_tbl(_idKhachHang, _tenKhachHang, _soDienThoai, _diaChi, _trangThai, _diemTichLuy, _tongTien, _tienKhach, _tienTraLai, _ngayMuaHang, _ghiChu, _TrangThaiGiaoDich);
138 return sp.FillDataSet_KhachHang_Count_ByNgayMua();
139 }
140 catch
141 {
142 return null;
143 }
144 }
145
146 //tbl_KhachHang_Get
147 public static DataSet FillDataSet_KhachHang_GetBy_IdKhachHang(int _idKhachHang)
148 {
149 try
150 {
151 Models.KhachHangMod_tbl sp = new Models.KhachHangMod_tbl(_idKhachHang);
152 return sp.FillDataSet_KhachHang_GetBy_IdKhachHang();
153 }
154 catch
155 {
156 return null;
157 }
158 }
159
160 //Dat tra hang
161 public static DataSet FillDataSet_KhachHang_DatTraHang()
162 {
163 try
164 {
165 Models.KhachHangMod_tbl sp = new Models.KhachHangMod_tbl();
166 return sp.FillDataSet_KhachHang_DatTraHang();
167 }
168 catch
169 {
170 return null;
171 }
172 }
173
174
175 }
176 }